• All Files

Create GUID

The Create GUID algorithm allows you to generate GUIDs (Globally Unique Identifiers) to identify resources and place them under the target column. Each row under the target column will contain a unique GUID.

 

Here is an example of GUID data generation:

 

Target Column
84264974-b93f-487a-8969-f742772f45d6
1fb19061-4a65-4a82-838a-f6e452ef9212
01a74999-62dc-48c9-b7b5-1036f8d7124b
13da05c2-79f6-4758-94b6-5175e16a6214
d4770dba-7991-4793-81ac-b3700146e0d7

 

To configure the Create GUID manipulate step, follow the instructions below:

 

  1. In the Admin Navigation tree, select Interfaces > InterfaceName > Tasks > TaskName > Steps.
  2. On the toolbar, click New >New Manipulate Step.

Creating a New Manipulate Step

  1. Navigate to the Keys section and select Create GUID.

Keys Section

  1. In the Create GUID work area, fill in the following fields:

Fields Configuration

The following table describes the fields available for this step:

 

Fields Description

Name

Provide a distinctive name for this step.

Is Active

Select the check box to engage the scheduler for this step.

Order of Execution

Enter the order in which this step should be executed.

Filter Expression

Optional. Use this filed to filter data from the source database prior to inserting it into the Schema table.

Sort Expression

Optional. Use this field to sort data from the source database prior to inserting it into the Schema table.

Stop interface execution if query failed

Optional. If enabled, the system will stop any data manipulation if the query returns an error.

Save Schema (enabled per interface)

If selected, the schema is created for this step.

Target Column

Specify the destination column where the result of the operation will be stored.

Save GUID for all rows

If selected, each row under the target column will hold the same GUID.

 

  1. Click the Save button.